package jmu.cze.mapper;

import jmu.cze.pojo.City;
import jmu.cze.vo.QueryResult;
import jmu.cze.vo.Terminal;
import jmu.cze.vo.TicketType;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;

@Repository
public interface QueryMapper {
    List<QueryResult> queryByCity(@Param("start") String start, @Param("end") String end, @Param("date") Date date);

    List<QueryResult> queryByFlightNo(@Param("flightNo") String flightNo, @Param("date") Date date);

    Terminal queryTerminal(Integer terminalID);

    String getModelName(Integer modelID);

    List<City> selectAllCity();

    List<TicketType> selectTicketTypes(Integer onFlightID);
}
